﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="1-3.aspx.cs" Inherits="ybqy_print_1_3" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
        <style type="text/css">
        table tr
        {
            border: 1px solid;
            padding: 5px 15px 5px 5px;
            height: 35px;
        }
        table td
        {
            border: 1px solid ;
            padding: 5px 15px 5px 5px;
            vertical-align: middle;
        }
        .style1
        {
            font-family: 宋体, Arial, Helvetica, sans-serif;
            font-size: small;
            width: 800px;
        }
       
    </style>

</head>
<body>
    <form id="form1" runat="server">
    <div>
    <span class="BiaoBiaoTi" >表1-3 上年主要产品、原辅材料年产(用)量</span>
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" border="1px" cellpadding="0" cellspacing="0"
            DataSourceID="SqlDataSource3" DataKeyNames="id" onrowdatabound="GridView1_RowDataBound" 
             
            
            Width="1041px"  
              
            >
            <Columns>
                <asp:TemplateField Visible="False">
                    <ItemTemplate>
                        <asp:Label ID="lbhidden" runat="server" Text='<%# Eval("id") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:BoundField DataField="PRODUCT_NAME" HeaderText="1.主要产品名称" 
                    SortExpression="PRODUCT_NAME">
                <ItemStyle Width="70px" />
                </asp:BoundField>
                <asp:BoundField DataField="PRODUCT_UNIT" HeaderText="2.计量单位" 
                    SortExpression="PRODUCT_UNIT">
                <ItemStyle Width="60px" />
                </asp:BoundField>
                <asp:BoundField DataField="PLAN_COUNT" HeaderText="3.设计年产量" 
                    SortExpression="PLAN_COUNT">
                <ItemStyle Width="70px" />
                </asp:BoundField>
                <asp:BoundField DataField="PRODUCT_COUNT" HeaderText="4.年产量" 
                    SortExpression="PRODUCT_COUNT">
                <ItemStyle Width="50px" />
                </asp:BoundField>
                <asp:TemplateField HeaderText="5.主要原辅材料名称|2.计量单位|6.用（耗）量">
                    <ItemTemplate>
                        <asp:GridView ID="GridView3" runat="server" AutoGenerateColumns="False" 
                            DataKeyNames="id" ShowHeader="False" Width="390px">
                            <Columns>
                                <asp:BoundField DataField="DATUM_NAME" HeaderText="DATUM_NAME" 
                                    SortExpression="DATUM_NAME" >
                                <ItemStyle Width="159px" Height="25px" />
                                </asp:BoundField>
                                <asp:BoundField DataField="DATUM_UNIT" HeaderText="DATUM_UNIT" 
                                    SortExpression="DATUM_UNIT" >
                                <ItemStyle Width="99px" Height="25px" />
                                </asp:BoundField>
                                <asp:BoundField DataField="DATUM_USE" HeaderText="DATUM_USE" 
                                    SortExpression="DATUM_USE" >
                                <ItemStyle Width="129px" Height="25px" />
                                </asp:BoundField>
                            </Columns>
                        </asp:GridView>
                    </ItemTemplate>
                    <HeaderStyle HorizontalAlign="Left" VerticalAlign="Middle" />
                    <ItemStyle Width="400px" />
                </asp:TemplateField>
                <asp:BoundField DataField="PRODUCT_WATER" HeaderText="7.单位产品用水量" 
                    SortExpression="PRODUCT_WATER">
                <ItemStyle Width="80px" />
                </asp:BoundField>
                <asp:BoundField DataField="PRODUCT_SOURCE" HeaderText="8.单位产品能耗量" 
                    SortExpression="PRODUCT_SOURCE">
                <ItemStyle Width="70px" />
                </asp:BoundField>
                <asp:BoundField DataField="PRODUCT_COAL" HeaderText="9.其中单位产品煤耗量" 
                    SortExpression="PRODUCT_COAL">
                <ItemStyle Width="90px" />
                </asp:BoundField>
            </Columns>
            <EmptyDataTemplate>
                <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" 
                    DataKeyNames="id" DataSourceID="SqlDataSource2">
                    <Columns>
                        <asp:BoundField DataField="DATUM_NAME" HeaderText="DATUM_NAME" 
                            SortExpression="DATUM_NAME" />
                        <asp:BoundField DataField="DATUM_UNIT" HeaderText="DATUM_UNIT" 
                            SortExpression="DATUM_UNIT" />
                        <asp:BoundField DataField="DATUM_USE" HeaderText="DATUM_USE" 
                            SortExpression="DATUM_USE" />
                    </Columns>
                </asp:GridView>
            </EmptyDataTemplate>
        </asp:GridView>
    </div>
        <asp:SqlDataSource ID="SqlDataSource3" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionStringole %>" 
            ProviderName="<%$ ConnectionStrings:ConnectionStringole.ProviderName %>" 
            
            SelectCommand="SELECT [id], [PRODUCT_NAME], [PRODUCT_UNIT], [PLAN_COUNT], [PRODUCT_COUNT], [PRODUCT_WATER], [PRODUCT_SOURCE], [PRODUCT_COAL] FROM [a01103] WHERE (([qiyeid] = ?) AND ([ShenBaoNianDu] = ?)) ORDER BY [id]" 
            OldValuesParameterFormatString="original_{0}" 
            DeleteCommand="select * from A01103">
            <SelectParameters>
                <asp:SessionParameter Name="qiyeid" SessionField="qiyeid" Type="String" />
                <asp:SessionParameter Name="ShenBaoNianDu" SessionField="ShenBaoNianDu" 
                    Type="String" />
            </SelectParameters>
        </asp:SqlDataSource>
        <asp:HiddenField ID="HiddenField_id" runat="server" />
    <asp:HiddenField ID="HiddenField_xiugai" runat="server" />
    </form>
</body>
</html>
